Scatter Chart - Satisfaction and Workload Impact on Attrition 18

1. Dimension and Placement: Create a Scatter Chart from the Visualizations pane. Set the dimensions to 331x367 and position it at Horizontal: 912 and Vertical: 388 on the dashboard.

2. Data Configuration: Set "Project Cnts" as the Values. Assign "Avg Monthly Hrs" for the X-axis and "Satisfaction %" for the Y-axis to dissect the correlation between workload and employee satisfaction against attrition.

3. Marker and Color Settings: Adjust the marker size to 29. For coloring, apply conditional formatting with a gradient format based on "Attrition %". Set the minimum value color to #F0E199 and the maximum value color to #B08F0A.

4. Axis Ranges and Formatting: Configure the X-axis range from 150 to 300 and the Y-axis range from 0 to 0.8 to encapsulate relevant data metrics. Customize X-axis values and titles with the color #DF1FDF,  X-axis values and titles with the color #4AC7B0 for enhanced clarity and distinction.

5. Aesthetics and Title:
6. Create Scatter Chart for Predictive Section: Following the same process, develop corresponding Scatter Chart for the predictive section, selecting appropriate predictive measures and metrics for each chart. Ensure these also follow the formatting standards and color schemes established in the historical section for consistency.

7. Managing Visibility for Sections:




Scatter charts in Power BI